Re: old db on a new system
От | Willy Wonka |
---|---|
Тема | Re: old db on a new system |
Дата | |
Msg-id | p05111704b9ba9e42bc46@[192.168.1.129] обсуждение исходный текст |
Ответ на | old db on a new system (Willy Wonka <lunchtime@onethirty.org>) |
Ответы |
Re: old db on a new system
|
Список | pgsql-admin |
after some playing, we finally got postgres 7.0.3 running, now on pg_dump, i get an error: > ./bin/pg_dumpall > dumped ERROR: Cannot insert a duplicate key into unique index pg_type_typname_index ERROR: Relation 'tmp_pg_shadow' does not exist ERROR: Relation 'tmp_pg_shadow' does not exist if i try just one database, i get this: > pg_dump immedia > immediadb Connection to database 'immedia' failed. FATAL 1: Database 'immedia', OID 18784, has disappeared from pg_database but the database is in pg_database. if i sound a bit lost, it's because i am. up until this point, all i had to do was install postgres, and somebody else used/maintained it. >ok, so i've got a pretty bad problem. >my system go borked last week, and i had to back everything up and reinstall. >i was running postgresql 7.0.* on openbsd2.8. >i switched to gentoo 1.2, and it emerged postgresql 7.2.2. > >now i've got some old databases on a new system that can't use them. >my brother tried installing postgresql 7.0.3 on his openbsd 3.1 >system [so i could do what the docs say, pg_dumpall], but can't get >it started because of some nasty shmget errors. >specifically: >IpcMemoryCreate: shmget failed (Permission denied) key=5432010, >size=144, permission=700 > >i really need to get these databases back online. is there anything i can do? >-- >=-=--------------------------------------------=-= > -.c.- > > My mistress when she walks treads on the ground.
В списке pgsql-admin по дате отправления: